UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SZmlwynAu935tqJSJlHv16bqPD41yX2eVP/c+ygM0mg='
WHERE
key_id = 'ec38d1645397dc535b108fe23dcc2e6849b1b1afa716621f62e6bdabb57ebf24'
AND (
token = 'SZmlwynAu935tqJSJlHv16bqPD41yX2eVP/c+ygM0mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)