UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8z1splVhfiyHdB8z2fTVqznYYQilJ4eN7OGpty2t7M='
WHERE
key_id = 'b32fdade169fc5776b80e2777981fa487f88fe54132a715e940616e2d86bb6a1'
AND (
token = 'G8z1splVhfiyHdB8z2fTVqznYYQilJ4eN7OGpty2t7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)