UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aFBHSRVEbAw4PMmVnF5g/zYc6HNt0j93v47+PVUV4B8='
WHERE
key_id = 'e9bf0a6072ef3921790ee59b7a5e296a50b06b9298a9b415d32065a8b6815495'
AND (
token = 'aFBHSRVEbAw4PMmVnF5g/zYc6HNt0j93v47+PVUV4B8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)