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