UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVjJIemezZB+Dy55NqITx+dAihHy1e2KptmD3fyK2yE='
WHERE
key_id = '04caee5a3e134143b27dfce5cd428cfc3451bc234420386db53e2423a5fb040b'
AND (
token = 'ZVjJIemezZB+Dy55NqITx+dAihHy1e2KptmD3fyK2yE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)