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