UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vR17K91Gn5ya+GUxrnxXnNNcifd/bJpkBkA2Q6mSUKg='
WHERE
key_id = 'd1ccf14096bbb78a5bac80ace562111ba97fab30685efea6d066ffd17f3a7bee'
AND (
token = 'vR17K91Gn5ya+GUxrnxXnNNcifd/bJpkBkA2Q6mSUKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)