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