UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/W9SwN9b4wLWWlwL9uE649baJZpFKdm/nOkrXDFlfB4='
WHERE
key_id = '123fa9eb934a3532f0682e004243fd5c1ea990e23bbecd68d6d6bd92d72bde4c'
AND (
token = '/W9SwN9b4wLWWlwL9uE649baJZpFKdm/nOkrXDFlfB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)