UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bmVW2yuqT7sbfeAO6A6ae4FZVjz9TcScPosgnK2tVFU='
WHERE
key_id = '76bccc96d2a32fca67d624aac35e6792b47c0c1ca85fc5d6ebeea3fbe9eb1f05'
AND (
token = 'bmVW2yuqT7sbfeAO6A6ae4FZVjz9TcScPosgnK2tVFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)