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