UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7/T5DLf8a5824WXc2VZfDOvmnzSZ1AvmrZuLthqAYWo='
WHERE
key_id = 'b30841093583a3b5cac58b184dc7c7e09706eb5ae9822e7122a71eccd6a7b093'
AND (
token = '7/T5DLf8a5824WXc2VZfDOvmnzSZ1AvmrZuLthqAYWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)