UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AlmbKk65LiAmAhWogJH03hnA/qvCPwNIkoNQvPDrrMs='
WHERE
key_id = 'bc9554673994e5a916de23849576ab8db8c469de13b3d3d8481c921a7e55c5f3'
AND (
token = 'AlmbKk65LiAmAhWogJH03hnA/qvCPwNIkoNQvPDrrMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)