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