UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jz04G+NVWngrVmifMru9hHyp8y3dhmTn6gFAGv0ZJlg='
WHERE
key_id = 'b2406b8219483925e67de2969197ef1861abc6516e1aa2342123c98d8a229577'
AND (
token = 'jz04G+NVWngrVmifMru9hHyp8y3dhmTn6gFAGv0ZJlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)