UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A2dr8Pibp7cVfnGHVhpaWfYwn29P1u6kjmH/873Ym14='
WHERE
key_id = '156d69636abac168e81413ffb88d1e5541ceb78a5cbb38986c6f3441007c9e71'
AND (
token = 'A2dr8Pibp7cVfnGHVhpaWfYwn29P1u6kjmH/873Ym14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)