UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bo0f0f2dLWZcpmvQAFx+tHVuhGdF6S+i1aKT46eXifw='
WHERE
key_id = 'd29553c4791f4311a88298e84a04dceb3032ba8693ada22415ccb0b13e4f4a9a'
AND (
token = 'Bo0f0f2dLWZcpmvQAFx+tHVuhGdF6S+i1aKT46eXifw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)