UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ng9gmXujO97xHdieGLNpnAB63hYMLuovQyrrxmKxoKA='
WHERE
key_id = '9b430bcddc808e1756f25ef70522a183ffa821f7b3238d999a894bc5df5eec21'
AND (
token = 'ng9gmXujO97xHdieGLNpnAB63hYMLuovQyrrxmKxoKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)