UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmghoqEr+UEKdsEvvmOD03jHLCicYZcq2AVhzUqLWjI='
WHERE
key_id = '246e96736ec11641b17a4c36df51a4b1282661c61a1394112af5e05e6bab78f9'
AND (
token = 'tmghoqEr+UEKdsEvvmOD03jHLCicYZcq2AVhzUqLWjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)