UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NvvIs5XYCi1Ybkbuanr/bItjnSE0GCwcKZPoZIUHdGQ='
WHERE
key_id = 'd3ea7e3d219efb028b12dda6917971d70cedf3bfeeb03df0f830e2e46eb4b5bf'
AND (
token = 'NvvIs5XYCi1Ybkbuanr/bItjnSE0GCwcKZPoZIUHdGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)