UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UsuW/SAEv+xlIPKXn41JMcnccD/i2BwU5WQ01wK/DLw='
WHERE
key_id = 'e28896f453208a276d8a53d0f51f1b6f72ad528f3512dc5531927ca160b6b587'
AND (
token = 'UsuW/SAEv+xlIPKXn41JMcnccD/i2BwU5WQ01wK/DLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)