UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HeIDKNXFBt1mB2/3VODFC9lSNZ13Vb+8JEXe6v6N8y8='
WHERE
key_id = 'dc48e94ed3c2db5a76251b5649577251b014b227e1901344a320556e9252f129'
AND (
token = 'HeIDKNXFBt1mB2/3VODFC9lSNZ13Vb+8JEXe6v6N8y8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)