UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z54wCwNdJP9Nz9KmLpLWZ3yAP1tdXSun0OFptW2wHfM='
WHERE
key_id = 'c23dd15ced5eb3f24ded3f98a52c63d9d172ddb8f7e6a8e2b7856fbffdb65306'
AND (
token = 'z54wCwNdJP9Nz9KmLpLWZ3yAP1tdXSun0OFptW2wHfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)