UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xwh9GjGkObNO5qFEeho+wXbgeeqe/3/zgKhag7Xuvvw='
WHERE
key_id = 'c47d8757cbe445c97d0f91f0e897f49466e59bf0ddc1c928cd425bcfbeba0433'
AND (
token = 'xwh9GjGkObNO5qFEeho+wXbgeeqe/3/zgKhag7Xuvvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)