UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xj+DCDs11Jk+WiKz2b8x+mzPDZz+vZqjGsIx6GJbtng='
WHERE
key_id = '4e31297312992dfbeecb01681c2f3a96eebe1be8352cc04faa9dbca91901608e'
AND (
token = 'Xj+DCDs11Jk+WiKz2b8x+mzPDZz+vZqjGsIx6GJbtng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)