UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M47T31Zl1bayLi5fvDFxaJ0B8Tbnk4IfjxDsUtC2oBo='
WHERE
key_id = '8201768d2bda2005258c49df7290096f0e042c0efbd942d3c33a1628e2c7dd2d'
AND (
token = 'M47T31Zl1bayLi5fvDFxaJ0B8Tbnk4IfjxDsUtC2oBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)