UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzCMY9vNgS/e+7yTLobWX18W36Xq8VpQpo5p/Iahrsg='
WHERE
key_id = '2e5a0ddc95e2113bfce35924f8c6f2ca42349c406dae852c985bad0c7e2187e3'
AND (
token = 'VzCMY9vNgS/e+7yTLobWX18W36Xq8VpQpo5p/Iahrsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)