UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ohpbnQ1r/3BCZoXykWFuv7JDtNoAcUbEWtxB0bNUVQ='
WHERE
key_id = '797fe8763ad97296af405434836ffc1c58678782e4fa21c533e53fb7ace160af'
AND (
token = '5ohpbnQ1r/3BCZoXykWFuv7JDtNoAcUbEWtxB0bNUVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)