UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OSIaTQGCKVSjIHknN6+HDC8GBv9HVcpS9RjeEGuMivY='
WHERE
key_id = '8a3ce8612ffb16078a01643bcd025ea477d4d546c985a738f5a9adab100b56b5'
AND (
token = 'OSIaTQGCKVSjIHknN6+HDC8GBv9HVcpS9RjeEGuMivY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)