UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'reOI7H+oTrz9uAR+zi2Amvg22jmgsTvqquxE7Z6tizs='
WHERE
key_id = '35c9034327a10d1a7995bfade82169eb715d1a33fe77c92573c0735c5c72ea7a'
AND (
token = 'reOI7H+oTrz9uAR+zi2Amvg22jmgsTvqquxE7Z6tizs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)