UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zL0BTFWm3PIVlqeNeOWCKAgQbXjjZTNkhcpEjVBwK60='
WHERE
key_id = '7b603f52d60d55bb0f30b49cb6bd33e70a86a2a23c6fb94c98d4a4a0d39be173'
AND (
token = 'zL0BTFWm3PIVlqeNeOWCKAgQbXjjZTNkhcpEjVBwK60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)