UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3944RcgWKvL4y8mUygJxlhZTVsrCgHSsPcArrH+VsU0='
WHERE
key_id = 'd9a4731a5f55f4484b199dde02ad8156bc7a9881dc80eba08bf47a4debb2a8be'
AND (
token = '3944RcgWKvL4y8mUygJxlhZTVsrCgHSsPcArrH+VsU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)