UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0/HjgMVVdYx6axUL9vJ+9UC2hM6mFVLmsADBcoZXgIs='
WHERE
key_id = '4847ab387bc752a1729c794a36f822668b87a654ec5fce857f99246c421b9f6e'
AND (
token = '0/HjgMVVdYx6axUL9vJ+9UC2hM6mFVLmsADBcoZXgIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)