UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K5v1/KYfE6sDQmKy63sKevuA0DkwsRK29tTwMa1cyY8='
WHERE
key_id = '5951f3cb23507d302bef4b0f948e296563413dfad98b7c955e63c7d648997c5e'
AND (
token = 'K5v1/KYfE6sDQmKy63sKevuA0DkwsRK29tTwMa1cyY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)