UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zdtbJQhOOAqcLZEOaCRWgpQCde5pCsPWplI/W6ddTI='
WHERE
key_id = '12871e5eb997ffd94962c155e6c50b3216abcff49621c74b108756653ab4a931'
AND (
token = '/zdtbJQhOOAqcLZEOaCRWgpQCde5pCsPWplI/W6ddTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)