UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8kQM1AZd2zgl1vrk4AbMqnK517jCHec/oXDIhTh3nM='
WHERE
key_id = '416e8df0521966a665f291e0209ba5f3ed2e8445b9b6df2965d3479f3cdfcc47'
AND (
token = 'W8kQM1AZd2zgl1vrk4AbMqnK517jCHec/oXDIhTh3nM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)