UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2qWQabmVIMzAyUklhBt4f5Onz0bCKpHFYQwyoJWMrCQ='
WHERE
key_id = 'c3757a0f7a45479da4a918aea9a71d7e56c8039541df267a9e6ed2592fdef525'
AND (
token = '2qWQabmVIMzAyUklhBt4f5Onz0bCKpHFYQwyoJWMrCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)