UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jA1w91fbfg0I/N26LDmDBuKj6m9g5ebL5nA63b0MHA='
WHERE
key_id = 'ffc57bae51abc54863ea4a5f157f5aec1c337bb81b062176ef74fda1d4df2ce1'
AND (
token = '9jA1w91fbfg0I/N26LDmDBuKj6m9g5ebL5nA63b0MHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)