UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yM+5hqgMwTshI8ylGOA8awTWrYosKeobXRo2MX50zSs='
WHERE
key_id = 'a47b3f2fd6518dd6fda27bea8edf7b1d6b47d3842ab0a6ef3a32e419a0e4f49c'
AND (
token = 'yM+5hqgMwTshI8ylGOA8awTWrYosKeobXRo2MX50zSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)