UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vfm597utokvgJgRODsd0htDuPnm6DI00cpvAmYiSQOU='
WHERE
key_id = 'b0aa44346ce13cbe17e4c863bad7688f5140851e2c89a479bddd3948462f2b47'
AND (
token = 'vfm597utokvgJgRODsd0htDuPnm6DI00cpvAmYiSQOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)