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