UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bp4cD3bL9joLbkY/uRNYyd9jT4eHCeB8GBDmZMnP+kU='
WHERE
key_id = '1e54bbf17ce8bb4f6ee207ad5581ffdb5a5312b903983ccbdc81790e728ebc6b'
AND (
token = 'Bp4cD3bL9joLbkY/uRNYyd9jT4eHCeB8GBDmZMnP+kU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)