UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPP9gPbIackds+VN2xBGavj+U3m992uvwLqXaEONq2A='
WHERE
key_id = '47e3f42649854e3e391e48081ec5b02df9012bc0be7d72136dbd683f884bec08'
AND (
token = 'qPP9gPbIackds+VN2xBGavj+U3m992uvwLqXaEONq2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)