UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2FQ1StJkMoMKp+JOmU83AFvBkhmOtBHDJwpJHqvH/3c='
WHERE
key_id = '4916f47441ab07255c94df982342a998ba667ea2a98a51d133e534af8107cc7c'
AND (
token = '2FQ1StJkMoMKp+JOmU83AFvBkhmOtBHDJwpJHqvH/3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)