UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HYsBcFN/M7JpnS+Y9d3TR0DNOatwRTDQUD+vC6YG9J4='
WHERE
key_id = 'fc07fb25f48d90f3862acc855502de6d6196496db68179d7687232b7accead56'
AND (
token = 'HYsBcFN/M7JpnS+Y9d3TR0DNOatwRTDQUD+vC6YG9J4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)